SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048521 LIMIT 1 [ RunTime:0.001149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048521 [ RunTime:0.007023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222454,121079,687590,565983,259712,948347,516327,826460,142485,653655,726622,323735,498055,464515,284121,860161,636894,271381,333826,101698,12151,465872,295146,586170,941594,732143,887764,309954,1030903,361350,696715,48607,417303,138086,547321,96086,857536,745534,132178,86014,589834,519443,380767,336788,111143,181052,203028,441763,543447,394392,1040736,515217,661767,539881,411349,765040,516258,842997,452499,544976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]