SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423770 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423770 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041117,974140,819430,896615,969542,268211,420989,680834,293121,563330,595146,238927,1026251,313396,676299,421114,916419,18038,828719,567594,379715,1040410,679889,649585,784019,506532,299834,609669,129770,656707,774125,383071,900798,649823,865462,80754,943583,360049,650343,823007,562441,162586,690861,307590,260082,251868,118829,1035910,100753,242417,791697,353744,10785,160767,735844,803386,759744,875281,151359,605731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]