SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173313 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173313 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329997,888208,84796,725836,643719,511993,178989,213696,98676,962403,426084,839436,180189,850751,782164,337207,604578,959248,19763,490471,638021,203367,692319,452290,847026,21132,102529,367808,776486,666461,827861,299316,101858,694771,1014172,625271,413631,628256,700117,701526,979025,473798,336484,422762,434903,764799,394692,538114,41897,804240,472282,477859,213363,598268,458817,537622,388840,169744,519080,865959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]