SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019320 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019320 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15164,691193,147144,985343,698306,114961,494326,838377,796050,577930,478260,146349,381563,597566,399348,844255,459825,931925,507689,134744,269543,249776,638643,977146,285816,899099,733600,11215,431360,446778,354156,641675,17565,745253,873673,999497,23809,834532,390125,684112,318786,451138,747611,226262,813600,502491,379518,170115,626739,1041624,1045423,1001576,1033783,829314,951149,1029499,645898,93073,849800,538161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]