SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377948 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377948 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456248,987926,704007,909500,912596,144844,535743,790439,685262,586037,906061,579540,27529,393488,856263,1016491,948950,224484,897605,993322,538366,321799,834008,119461,1007981,210088,545406,331829,11133,326173,1938,773993,813960,148613,205700,770670,1036275,667479,13621,637229,458284,285924,257674,120195,745423,564062,800766,695887,456518,729616,411859,989952,704347,119770,449867,253035,687714,898883,947272,267783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001268s ]