SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3433 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3433 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027672,145396,253402,632372,598768,243883,305736,63196,284535,868147,510247,933960,244125,629331,945864,241549,249713,467249,337744,578890,985566,185329,112724,53949,300403,213574,951257,692735,590342,993596,681110,770204,117832,495174,122518,499538,803891,560575,764321,375541,474779,821913,373087,532030,748199,784149,263321,266841,859808,588544,932630,674709,597695,1037827,982954,946347,1001461,542862,141536,647533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]