SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974013 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974013 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874164,614924,864849,90427,255702,762363,640420,417207,32600,179504,134085,312819,231342,807268,1007484,276784,732151,175424,892893,277334,815158,1038296,784579,165162,1030457,736534,1028541,553029,16617,669618,595448,818660,533135,193585,65163,603889,499795,502272,882090,663551,572891,1015688,654550,208023,858352,851276,284198,1016,1045351,769771,194838,979673,110792,695518,620351,670880,86348,30367,170368,135764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]