SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020284 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020284 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735426,208676,970586,482541,166526,390732,234093,730109,349101,278517,563920,730,993613,398846,420126,919892,421782,459156,862355,215650,330269,540050,1048388,871218,761759,1021951,466902,1037633,595061,63753,231996,885686,89182,64334,754382,168632,970174,213511,66704,761170,497699,271571,24062,693204,1127,915739,1043772,566295,243855,684249,395837,1039224,534780,293466,584874,148291,240056,263841,939595,921429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]