SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106599 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106599 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737471,64115,239801,174976,569605,609906,195782,941945,770710,107507,841781,340789,440104,750219,691158,762599,568371,922899,716415,439941,30821,579775,306041,390898,774354,534573,550241,955122,166425,709250,699253,903764,430932,842713,73241,430651,442387,565362,443913,634570,224453,173488,653051,879489,866591,863295,407277,9688,452975,949271,199296,430408,837187,800571,881775,993429,116341,535500,752452,432626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]