SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506405 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506405 [ RunTime:0.003424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545985,651723,784567,457806,430785,85152,445522,354866,806462,350740,801226,901242,409414,980604,507839,323990,66124,583146,1008792,471075,663856,97789,919059,883830,272128,63060,446074,30490,229861,390419,495235,340487,190727,696500,552755,1048655,491696,684053,519668,768907,651699,443426,139399,36472,913537,760607,481668,430757,925087,737117,276920,398923,835543,622687,90225,16634,918076,263509,23247,1024880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]