SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5159 LIMIT 1 [ RunTime:0.001720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5159 [ RunTime:0.005357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357101,1016472,862556,465180,592142,425657,328397,388244,78951,769584,188473,686974,699372,484466,479881,1021033,119646,36032,397502,108781,661832,108554,695398,732542,723515,473033,300839,49667,665465,537681,893464,717747,701987,443448,307329,640157,1036975,947702,1025433,899567,729810,440116,441605,990927,373837,980182,468133,597400,577559,151551,290815,13041,446074,738177,326039,832598,559023,458783,529203,701788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]