SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189928 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189928 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046952,162011,171094,1044873,441066,987570,434282,907520,746210,77225,409557,553815,454834,784430,172997,187552,818770,732112,610313,424902,16919,287758,25450,582687,46255,569867,980931,724423,437572,490455,955024,852536,653382,1033796,264303,384488,1033033,593226,462133,533632,6310,887180,1018784,59588,65725,412356,1007805,755286,708382,514875,357284,1041776,955687,708817,506900,836502,1041566,699475,725480,617914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001149s ]