SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014843 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014843 [ RunTime:0.003572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102181,925174,819748,356119,552288,959736,22877,149045,808318,778043,9014,37627,856461,424073,421699,894091,1037584,636719,337621,5226,509397,117297,475197,1012595,953947,882466,680312,312336,884137,725359,965725,169788,622734,395348,746141,1044764,716659,46577,722107,503715,7509,406639,862940,703294,719472,299466,1025698,478632,7381,42459,515116,986860,968133,774825,104908,435637,517985,428689,840226,624521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]