SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020774 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020774 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794216,85260,679667,965569,244844,515340,20075,56317,880143,673517,1032479,812922,119329,1022662,261355,209378,607327,310714,379146,42550,618317,723433,974641,911422,538496,383137,1002304,623242,326990,465552,1016793,542567,556143,350927,345695,423516,159356,379004,250341,658954,344525,486854,373561,375674,347951,378233,1048589,820355,582834,322314,572180,421624,141984,943439,458825,671865,216751,909848,283881,116294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]