SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19541 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19541 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124138,809185,111374,761269,1006127,384961,94018,50108,881564,109583,754534,151332,21654,641840,258863,722991,970735,748546,698263,342155,66285,86824,814077,211856,545720,402022,735800,483953,65808,440070,735517,913297,462763,773301,865222,767420,366297,77357,1008895,885219,190889,303001,185395,1001378,657050,931743,827662,596336,159599,23697,606126,213710,541042,147947,589491,982287,101820,735581,88609,778893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]