SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287145 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287145 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929443,1048280,168623,570085,804142,834220,496042,1041273,258994,699700,1003403,904602,258342,440868,220630,690818,741018,499640,382426,903806,994510,964534,32265,840167,806891,645571,390926,1042625,681438,1024938,806098,57000,354674,90484,441604,244208,1010345,372017,784508,843613,105711,771664,520727,534961,799155,317885,1641,488267,818729,943595,1004670,1001579,979161,203635,811912,493847,353463,14820,470557,317561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001333s ]