SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105265 LIMIT 1 [ RunTime:0.001806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105265 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503794,811660,321109,565932,163563,881709,752967,320714,187577,210598,712972,808432,141451,652096,371021,1022947,761060,707450,551701,617178,895058,449561,87306,385673,741792,976952,347830,314906,293447,331450,191027,840167,633760,400146,417109,1015906,450494,717360,876541,617015,333014,759608,189028,827851,566159,191132,343280,557524,58686,444887,733096,197688,124107,993111,325207,112437,678779,983863,260305,810809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105265 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105265 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]